Skip to main content link. Accesskey S
  • Help
  • HCL Logo
  • HCL Notes and Domino Application Development wiki
  • THIS WIKI IS READ-ONLY. Individual names altered for privacy purposes.
  • HCL Forums and Blogs
  • Home
  • Product Documentation
  • Community Articles
  • Learning Center
  • API Documentation
Search
Community Articles > Developing Applications > Run Lotus Notes Text Data via URL in JDeveloper
  • Share Show Menu▼
  • Subscribe Show Menu▼

Recent articles by this author

Run Lotus Notes Text Data via URL in JDeveloper

Knowledge Sharing Döcu Content Read Lotus Notes Data via URL in JDeveloper XpagesJSF Application Introduction: Read App Data from Lotus Notes Database into Java Server Faces Page on JDeveloper, running on Weblogic Server Current Lotus Notes JavaAgent, code running the actual TXT file ...

New Doc: Read Lotus Notes Text Data via URL in JDeveloper

Knowledge Sharing JDeveloper Read Lotus Notes Data via URL Part 3 Introduction: Read App Data from Lotus Notes Database into Java Server Faces Page on JDeveloper, running on Weblogic Server Going forward , we will be looking at the data through TXT data in URL from Lotus Notes Database, ...

Read Lotus Notes Text Data via URL in JDeveloper

Knowledge Sharing JDeveloper Read Lotus Notes Data via URL Part 3 Introduction: Read App Data from Lotus Notes Database into Java Server Faces Page on JDeveloper, running on Weblogic Server Going forward , we will be looking at the data through TXT data in URL from Lotus Notes ...

Read Lotus Notes Data via URL in JDeveloper

Knowledge Sharing JDeveloper Read Lotus Notes Data via URL Part 3 Introduction: Read App Data from Lotus Notes Database into Java Server Faces Page on JDeveloper, running on Weblogic Server Going forward , we will be looking at the data through TXT data in URL from Lotus Notes ...

Google WorkSheets Xpages App (Google Drive)

Knowledge Sharing Döcu Content Google Worksheets inputText JavaAgentJavaBean Xpages Application System Requirements: Download Domino Designer 8.5.3 Environment (DDE) http:www.ibm.comdeveloperworksdownloadslsdominodesigner Download Make available Google Spreadsheets API ...
Community articleRun Lotus Notes Text Data via URL in JDeveloper
Added by ~Zelda Frokrotexettu | Edited by ~Zelda Frokrotexettu on September 7, 2015 | Version 13
  • Actions Show Menu▼
expanded Abstract
collapsed Abstract
No abstract provided.
Tags: JDeveloper, Xpages, JavaAgent, JSF

Knowledge Sharing

 

Döcu Content

Read Lotus Notes Data via URL in JDeveloper

Xpages/JSF Application

 

Introduction:

Read App Data from Lotus Notes Database into Java Server Faces Page on JDeveloper, running on Weblogic Server

 

 

Current Lotus Notes JavaAgent, code running the actual TXT file shown in the URL

 

Site URL

http://localhost/docucontent.nsf/javaagentfeedcsvexternalsites.txt

 

 

/**

* Created from copy: 2015.07.04.12.39.PM

* HTTPDDECSVDataJDevJavaAgent

* CSV data for Xpages to be read by Oracle JDeveloper Apps

*/

 

load imports

import lotus.domino.*;

import lotus.domino.local.Database;

import java.io.PrintWriter;

 

/**

* @author Dököll Solutions, Inc.

* @version 2015.07.04.12.39.PM

*

*/

 

begin class

public class JavaAgent extends AgentBase {

 

open method, this actually runs the whole App

public void NotesMain() {

 

let's add a try catch here, to grab errors near the end

try {

open our session...

Session session = getSession();

load info to console for debugging purposes

System.out

.println("HTTPDDECSVDataJDevJavaAgent System User, We've got a session..."

+ session);

 

load agentContext

AgentContext agentContext = session.getAgentContext();

...

System.out.println("got HTTPDDECSVDataJDevJavaAgent agentContext..."

+ agentContext);

find database based on session found

Database database = (Database) agentContext.getCurrentDatabase();

Find view in question according to current database

View view = database.getView("IssuesListings");

System.out.println("View Obtained..." + view);

 

declare document variables

Document currDoc;

Document tempDoc;

grab first doc

currDoc = view.getFirstDocument();

 

PrintWriter...

PrintWriter pw = getAgentOutput();

System.out

.println("URL: http://localhost/docucontent.nsf/javaagentfeedcsvexternalsites.txt");

 

Content type set at Txt

 TODO: Figure out a better version to load a CSV file to browser

currently, the csv downloads to local directory

pw.println("Content-type:text/txt");

 

while (currDoc != null) {

 

write records from view into a Text file and show it in the

browser

pw.println(currDoc.getItemValueString("UserID") + " "

+ currDoc.getItemValueString("PageID") + " "

+ currDoc.getItemValueString("priority") + " "

+ currDoc.getItemValueString("issues"));

 

Get next document

tempDoc = view.getNextDocument(currDoc);

recycle currDoc

currDoc.recycle();

set currDoc to tempDoc

currDoc = tempDoc;

}

 

} catch (Exception e) {

e.printStackTrace();

}

}

}

 

 

 

 

 

JDeveloper Test Log

 

Second attempt to connect JDeveloper with Lotus Notes

 

*** Using HTTP port 7101 ***

*** Using SSL port 7102 ***

C:\Users\Administrator\AppData\Roaming\JDeveloper\system12.1.3.0.41.140521.1008\DefaultDomain\bin\startWebLogic.cmd

[Starting IntegratedWebLogicServer.]

[waiting for the server to complete its initialization...]

.

.

JAVA Memory arguments: -Xms256m -Xmx512m -XX:PermSize=128m -XX:MaxPermSize=512m

.

CLASSPATH=C:\Oracle\Middleware\Oracle_Home\oracle_common\modules\features\com.oracle.db.jdbc7-dms.jar;C:\Oracle\MIDDLE~1\ORACLE~2\ORACLE~1\jdk\lib\tools.jar;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server\lib\weblogic_sp.jar;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server\lib\weblogic.jar;C:\Oracle\MIDDLE~1\ORACLE~2\oracle_common\modules\net.sf.antcontrib_1.1.0.0_1-0b3\lib\ant-contrib.jar;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\modules\features\oracle.wls.common.nodemanager_2.0.0.0.jar;C:\Oracle\Middleware\Oracle_Home\oracle_common\modules\internal\features\jrf_wlsFmw_oracle.jrf.wls.classpath_12.1.3.jar;C:\Oracle\MIDDLE~1\ORACLE~2\oracle_common\modules\com.oracle.cie.config-wls-online_8.1.0.0.jar;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\common\derby\lib\derbynet.jar;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\common\derby\lib\derbyclient.jar;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\common\derby\lib\derby.jar;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server\lib\xqrl.jar;C:\PROGRA~2\OPENOF~1.ORG\Basis\program;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\JCOMMO~2.JAR;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\JFREEC~2.JAR;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\POI-25~1.JAR;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\POI-35~1.JAR;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\csvjdbc.jar;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\JASPER~1.JAR;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\iReport.jar;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\COMMON~1.JAR;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\COMMON~2.JAR;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\COMMON~3.JAR;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\ITEXT-~1.JAR;C:\PROGRA~1\IBM\SQLLIB\java\db2java.zip;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc4.jar;C:\PROGRA~1\IBM\SQLLIB\java\sqlj.zip;C:\PROGRA~1\IBM\SQLLIB\java\DB2JCC~1.JAR;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\java\Common.jar;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\COMMON~1.PRO;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\CO49EF~1.JAR

.

PATH=;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server\native\win\x64;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server\bin;C:\Oracle\MIDDLE~1\ORACLE~2\oracle_common\modules\org.apache.ant_1.9.2\bin;C:\Oracle\MIDDLE~1\ORACLE~2\ORACLE~1\jdk\jre\bin;C:\Oracle\MIDDLE~1\ORACLE~2\ORACLE~1\jdk\bin;C:\app\ADMINI~1\product\112~1.0\dbhome_4\BIN;C:\PROGRA~1\COMMON~1\MICROS~1\WINDOW~1;C:\PROGRA~2\COMMON~1\MICROS~1\WINDOW~1;C:\Windows\System32;C:\Windows;C:\Windows\System32\wbem;C:\Windows\System32\WINDOW~1\v1.0\;C:\PROGRA~2\COMMON~1\ROXIOS~1\DLLSHA~1\;c:\PROGRA~2\MI3EDC~1\100\Tools\Binn\;c:\PROGRA~2\MI3EDC~1\100\Tools\Binn\VSShell\Common7\IDE\;c:\PROGRA~2\MI3EDC~1\100\DTS\Binn\;C:\PROGRA~2\WIC4A1~1\Shared;C:\PROGRA~2\COMMON~1\SOFTIM~1;C:\PROGRA~1\COMMON~1\SOFTIM~1;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\PROGRA~1\IBM\SQLLIB\samples\repl;C:\PROGRA~1\INTERN~1;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server\native\win\x64\oci920_8

.

***************************************************

* To start WebLogic Server, use a username and *

* password assigned to an admin-level user. For *

* server administration, use the WebLogic Server *

* console at http:\\hostname:port\console *

***************************************************

starting weblogic with Java version:

java version "1.7.0_51"

Java(TM) SE Runtime Environment (build 1.7.0_51-b13)

Java HotSpot(TM) 64-Bit Server VM (build 24.51-b03, mixed mode)

Starting WLS with line:

C:\Oracle\MIDDLE~1\ORACLE~2\ORACLE~1\jdk\bin\java -server -Xms256m -Xmx512m -XX:PermSize=128m -XX:MaxPermSize=512m -Dweblogic.Name=DefaultServer -Djava.security.policy=C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server\lib\weblogic.policy -Doracle.jdeveloper.adrs=true -Dweblogic.nodemanager.ServiceEnabled=true -Xverify:none -Djava.endorsed.dirs=C:\Oracle\MIDDLE~1\ORACLE~2\ORACLE~1\jdk\jre\lib\endorsed;C:\Oracle\MIDDLE~1\ORACLE~2\oracle_common\modules\endorsed -Djava.protocol.handler.pkgs="oracle.mds.net.protocol" -Dopss.version=12.1.3 -Digf.arisidbeans.carmlloc=C:\Users\ADMINI~1\AppData\Roaming\JDEVEL~1\SYSTEM~1.100\DEFAUL~1\config\fmwconfig\carml -Digf.arisidstack.home=C:\Users\ADMINI~1\AppData\Roaming\JDEVEL~1\SYSTEM~1.100\DEFAUL~1\config\fmwconfig\arisidprovider -Doracle.security.jps.config=C:\Users\ADMINI~1\AppData\Roaming\JDEVEL~1\SYSTEM~1.100\DEFAUL~1\config\fmwconfig\jps-config.xml -Doracle.deployed.app.dir=C:\Users\ADMINI~1\AppData\Roaming\JDEVEL~1\SYSTEM~1.100\DEFAUL~1\servers\DefaultServer\tmp\_WL_user -Doracle.deployed.app.ext=\- -Dweblogic.alternateTypesDirectory=C:\Oracle\Middleware\Oracle_Home\oracle_common\modules\oracle.ossoiap_12.1.3,C:\Oracle\Middleware\Oracle_Home\oracle_common\modules\oracle.oamprovider_12.1.3,C:\Oracle\Middleware\Oracle_Home\oracle_common\modules\oracle.jps_12.1.3 -Dweblogic.jdbc.remoteEnabled=false -Dcommon.components.home=C:\Oracle\Middleware\Oracle_Home\oracle_common -Djrf.version=12.1.3 -Dorg.apache.commons.logging.Log=org.apache.commons.logging.impl.Jdk14Logger -Ddomain.home=C:\Users\ADMINI~1\AppData\Roaming\JDEVEL~1\SYSTEM~1.100\DEFAUL~1 -Doracle.server.config.dir=C:\Users\ADMINI~1\AppData\Roaming\JDEVEL~1\SYSTEM~1.100\DEFAUL~1\config\fmwconfig\servers\DefaultServer -Doracle.domain.config.dir=C:\Users\ADMINI~1\AppData\Roaming\JDEVEL~1\SYSTEM~1.100\DEFAUL~1\config\fmwconfig -Doracle.mds.filestore.preferred=true -Dadf.version=12.1.3 -da -Dwls.home=C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server -Dweblogic.home=C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server -Djps.app.credential.overwrite.allowed=true -Djavax.management.builder.initial=weblogic.management.jmx.mbeanserver.WLSMBeanServerBuilder -Djava.util.logging.manager=oracle.core.ojdl.logging.ODLLogManager weblogic.Server

Jul 04, 2015 12:58:37 PM oracle.security.jps.JpsStartup start

INFO: Jps initializing.

Jul 04, 2015 12:58:50 PM oracle.security.jps.internal.idstore.util.LibOvdUtil pushLdapNamesToLibOvd

INFO: Pushed ldap name and types info to libOvd. Ldaps : DefaultAuthenticator:idstore.ldap.provideridstore.ldap.

Jul 04, 2015 12:58:57 PM oracle.security.jps.JpsStartup start

INFO: Jps started.

2015-07-04 12:59:32.724/112.272 Oracle Coherence 12.1.3.0.0 (thread=[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)', member=n/a): Loaded operational configuration from "jar:file:/C:/Oracle/Middleware/Oracle_Home/coherence/lib/coherence.jar!/tangosol-coherence.xml"

2015-07-04 12:59:32.970/112.518 Oracle Coherence 12.1.3.0.0 (thread=[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)', member=n/a): Loaded operational overrides from "jar:file:/C:/Oracle/Middleware/Oracle_Home/coherence/lib/coherence.jar!/tangosol-coherence-override-dev.xml"

2015-07-04 12:59:33.410/112.958 Oracle Coherence 12.1.3.0.0 (thread=[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)', member=n/a): Optional configuration override "/tangosol-coherence-override.xml" is not specified

2015-07-04 12:59:33.462/113.010 Oracle Coherence 12.1.3.0.0 (thread=[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)', member=n/a): Optional configuration override "cache-factory-config.xml" is not specified

2015-07-04 12:59:33.500/113.048 Oracle Coherence 12.1.3.0.0 (thread=[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)', member=n/a): Optional configuration override "cache-factory-builder-config.xml" is not specified

2015-07-04 12:59:33.564/113.112 Oracle Coherence 12.1.3.0.0 (thread=[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)', member=n/a): Optional configuration override "/custom-mbeans.xml" is not specified

 

Oracle Coherence Version 12.1.3.0.0 Build 52031

Grid Edition: Development mode

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

 

Jul 04, 2015 12:59:57 PM oracle.dms.servlet.DMSServletFilter setEagerlySetContextValues

INFO: The setting that controls the eager fetching of some types of execution context data has been set to true.

IntegratedWebLogicServer startup time: 514642 ms.

[IntegratedWebLogicServer started.]

[Running application MyWebNews on IntegratedWebLogicServer...]

[02:12:16 PM] Web Module ViewControllerWebApp.war recognized in project ViewController.jpr

[02:12:21 PM]


Deployment started.

[02:12:21 PM] Target platform is (Weblogic 12.x).

[02:13:10 PM] Retrieving existing application information

[02:13:11 PM] Running dependency analysis...

[02:13:11 PM] Deploying 2 profiles...

[02:13:14 PM] Wrote Web Application Module to C:\Users\Administrator\AppData\Roaming\JDeveloper\system12.1.3.0.41.140521.1008\o.j2ee\drs\MyWebNews\ViewControllerWebApp.war

[02:13:17 PM] Wrote Enterprise Application Module to C:\Users\Administrator\AppData\Roaming\JDeveloper\system12.1.3.0.41.140521.1008\o.j2ee\drs\MyWebNews

[02:13:17 PM] Deploying 1 data source(s) to the server...

[02:13:24 PM] Redeploying Application...

[02:17:31 PM] Application Redeployed Successfully.

[02:17:33 PM] The following URL context root(s) were defined and can be used as a starting point to test your application:

[02:17:33 PM] http://localhost:7101/MyWebNews-ViewController-context-root

[02:17:33 PM] http://localhost:7101/MyWebNews-ViewController-context-root

[02:17:33 PM] Elapsed time for deployment: 5 minutes, 12 seconds

[02:17:33 PM]


Deployment finished.

Run startup time: 316008 ms.

[Application MyWebNews running on IntegratedWebLogicServer]

 

 

 

JDeveloper JSF URL

 

 

Target URL -- http://localhost:7101/MyWebNews-ViewController-context-root/faces/jdlotusfeed.jsf

 

<_checkTimestamp>

 

Lotus Notes Data in JDeveloper Console

 

AlienHouse http://localhost/docucontent.nsf/xpissuesformnewuser.xsp Low Testing

username107 http://localhost/docucontent.nsf/xpusersubmit.xsp Low I need more Cow Bells

 

Notes Log

 

07/04/2015 01:12:35 PM XSP Command Manager initialized
07/04/2015 01:12:35 PM No statistics block. HTTP load statistics will not be collected
07/04/2015 01:12:35 PM HTTP Server: Started
07/04/2015 01:13:28 PM HTTP JVM: HTTPDDECSVDataJDevJavaAgent System User, We've got a session...CN=cherizards/O=cherizards
07/04/2015 01:13:28 PM HTTP JVM: got HTTPDDECSVDataJDevJavaAgent agentContext...CN=cherizards/O=cherizards
07/04/2015 01:13:28 PM HTTP JVM: View Obtained...IssuesListings
07/04/2015 01:13:28 PM HTTP JVM: URL: http://localhost/docucontent.nsf/javaagentfeedcsvexternalsites.txt
07/04/2015 01:13:47 PM HTTP JVM: HTTPDDECSVDataJDevJavaAgent System User, We've got a session...CN=cherizards/O=cherizards
07/04/2015 01:13:47 PM HTTP JVM: got HTTPDDECSVDataJDevJavaAgent agentContext...CN=cherizards/O=cherizards
07/04/2015 01:13:47 PM HTTP JVM: View Obtained...IssuesListings
07/04/2015 01:13:47 PM HTTP JVM: URL: http://localhost/docucontent.nsf/javaagentfeedcsvexternalsites.txt
07/04/2015 02:19:06 PM HTTP JVM: HTTPDDECSVDataJDevJavaAgent System User, We've got a session...CN=cherizards/O=cherizards
07/04/2015 02:19:06 PM HTTP JVM: got HTTPDDECSVDataJDevJavaAgent agentContext...CN=cherizards/O=cherizards
07/04/2015 02:19:07 PM HTTP JVM: View Obtained...IssuesListings
07/04/2015 02:19:08 PM HTTP JVM: URL: http://localhost/docucontent.nsf/javaagentfeedcsvexternalsites.txt
07/04/2015 02:27:15 PM XSP Command Manager terminated
07/04/2015 02:28:19 PM HTTP Server: Shutdown

 

 

JavaAgent Properties

 


 

 

 

 

 

 

 

 

 

 

 

version: 2015.07.05.12.20.AM


  • Actions Show Menu▼


expanded Attachments (0)
collapsed Attachments (0)
Edit the article to add or modify attachments.
expanded Versions (13)
collapsed Versions (13)
Version Comparison     
VersionDateChanged by              Summary of changes
This version (13)Sep 7, 2015, 1:06:12 PM~Zelda Frokrotexettu  
12Sep 7, 2015, 1:05:41 PM~Tanita Brehipimar  
11Sep 7, 2015, 1:04:57 PM~Tanita Brehipimar  
10Sep 7, 2015, 1:04:02 PM~Tanita Brehipimar  
9Jul 26, 2015, 12:14:30 AM~Tanita Brehipimar  
8Jul 26, 2015, 12:13:47 AM~Tanita Brehipimar  
7Jul 26, 2015, 12:13:17 AM~Tanita Brehipimar  
6Jul 26, 2015, 12:12:46 AM~Tanita Brehipimar  
5Jul 26, 2015, 12:12:02 AM~Tanita Brehipimar  Fix Headers
4Jul 26, 2015, 12:08:46 AM~Tanita Brehipimar  
3Jul 26, 2015, 12:07:36 AM~Tanita Brehipimar  
2Jul 26, 2015, 12:07:09 AM~Tanita Brehipimar  
1Jul 26, 2015, 12:05:17 AM~Tanita Brehipimar  
expanded Comments (0)
collapsed Comments (0)
Copy and paste this wiki markup to link to this article from another article in this wiki.
Go ElsewhereStay ConnectedAbout
  • HCL Software
  • HCL Digital Solutions community
  • HCL Software support
  • BlogsDigital Solutions blog
  • Community LinkHCL Software forums and blogs
  • About HCL
  • Privacy
  • Accessibility